package com.jz.netthings.application.heatseal.mapper.mysql;

import com.jz.netthings.application.heatseal.bean.HeatSeal;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.jz.netthings.application.heatseal.bean.PlasmaStock;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 热合表 Mapper 接口
 * </p>
 *
 * @author lzf
 * @since 2019-03-18
 */
public interface HeatSealMapper extends BaseMapper<HeatSeal> {

    @Select("SELECT MAX(plasmaNo) FROM heat_seal")
    String getMaxPlasmaNo();

    /**
     * 根据入库日期，查询入库箱号集合
     * @param beginTime
     * @param endTime
     * @return
     */
    List<Map<String, String>> getHeatSealBoxByDate(@Param("beginTime") String beginTime,@Param("endTime") String endTime);
    /**
     * 根据箱号，查询合计袋数和合计重量
     * @param boxNum
     * @return
     */
    Map<String, String> getHeatByBox(@Param("boxNum") String boxNum);
    /**
     * 根据箱号，查询血浆入库、化检信息
     * @param boxNum
     * @return
     */
    List<PlasmaStock> getPlasmaInfoBox(@Param("boxNum") String boxNum);

}
